CREATE PROCEDURE FacultiesSearch
@Name VARCHAR(40) = '%'
AS
BEGIN

DECLARE @SName VARCHAR(50) = '%'+@Name+'%';

SELECT 
	FacultyAutoId,
	Name,
	Designation,
	email,
	Phone,
	Location
FROM Faculty WHERE Name like @Sname;
END
